/*
 Navicat Premium Dump SQL

 Source Server         : docker-mysql
 Source Server Type    : MySQL
 Source Server Version : 90200 (9.2.0)
 Source Host           : localhost:3306
 Source Schema         : e_admin

 Target Server Type    : MySQL
 Target Server Version : 90200 (9.2.0)
 File Encoding         : 65001

 Date: 25/05/2025 04:41:12
*/


-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO admin.sys_config (config_id, config_key, config_name, config_value, config_type, remark, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag, tenant_id) VALUES ('1908914666614530050', 'demo', '测试', 'demo', '1', '测试', 0, 'CS', 'IY', 'admin', '2025-04-07 00:08:17', 'admin', '2025-04-07 03:06:34', '0', '0');
INSERT INTO admin.sys_config (config_id, config_key, config_name, config_value, config_type, remark, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag, tenant_id) VALUES ('1908943328009187329', 'ENABLE_ROLE_MENU', '启用角色菜单', '1', '0', '1 启用 0 禁用', 0, 'QYJSCD', 'YEQQAU', 'admin', '2025-04-07 02:02:11', 'admin', '2025-04-07 03:06:31', '0', '0');
INSERT INTO admin.sys_config (config_id, config_key, config_name, config_value, config_type, remark, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag, tenant_id) VALUES ('1908954137183596545', 'ENABLE_DEPT_MENU', '启用部门菜单', '1', '0', '1 启用 0 禁用', 0, 'QYBMCD', 'YEUUAU', 'admin', '2025-04-07 02:45:08', 'admin', '2025-04-07 03:06:28', '0', '0');
INSERT INTO admin.sys_config (config_id, config_key, config_name, config_value, config_type, remark, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag, tenant_id) VALUES ('1909662442084302850', 'ENABLE_USER_MENU', '开启用户菜单', '1', '0', '单独配置用户的菜单，不是部门或者角色配置的', 0, 'KQYHCD', 'GYEYAU', 'admin', '2025-04-09 01:39:41', 'admin', '2025-10-02 12:47:21', '0', '0');
INSERT INTO admin.sys_config (config_id, config_key, config_name, config_value, config_type, remark, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag, tenant_id) VALUES ('1974024061544411138', 'ENABLE_USER_MULTIPLE_POST', '允许用户多岗位', '1', '0', '1：允许一个用户配置多个岗位，0：一个用户只能一个岗位', 0, 'YXYHDGW', 'CYEYQMW', 'admin', '2025-10-03 16:09:47', 'admin', '2025-10-09 02:42:39', '0', '0');
INSERT INTO admin.sys_config (config_id, config_key, config_name, config_value, config_type, remark, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag, tenant_id) VALUES ('1975673176502153217', 'ENABLE_USER_MULTIPLE_DEPT', '允许用户多部门', '1', '0', '1：允许一个用户配置多个部门，0：一个用户只能一个部门', 0, 'YXYHDBM', 'CYEYQUU', 'admin', '2025-10-08 05:22:46', 'admin', '2025-10-09 02:42:34', '0', '0');
COMMIT;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903362923901349889', '0', '行政中心', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'XZZX', 'TGKN', 'admin', '2025-03-22 16:27:38', 'admin', '2025-03-22 16:27:38', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903362997133897729', '0', '技术中心', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'JSZX', 'RSKN', 'admin', '2025-03-22 16:27:56', 'admin', '2025-03-22 16:27:56', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363063101911041', '0', '营销中心', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'YXZX', 'AQKN', 'admin', '2025-03-22 16:28:12', 'admin', '2025-03-22 16:28:12', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363205993459714', '1903362923901349889', '财务部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'CWB', 'MTU', 'admin', '2025-03-22 16:28:00', 'admin', '2025-03-22 16:28:00', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363235735269378', '1903362923901349889', '人事部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'RSB', 'WGU', 'admin', '2025-03-22 16:28:00', 'admin', '2025-03-22 16:28:00', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363435082149890', '1903362997133897729', '实施部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'SSB', 'PYU', 'admin', '2025-03-22 16:29:40', 'admin', '2025-03-22 16:29:40', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363484398776322', '1903362997133897729', '产品部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'CPB', 'UKU', 'admin', '2025-03-22 16:29:52', 'admin', '2025-03-22 16:29:52', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363739001417730', '1903362997133897729', '测试部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'CSB', 'IYU', 'admin', '2025-03-22 16:30:53', 'admin', '2025-03-22 16:30:53', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903363796165586946', '1903362997133897729', '研发部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'YFB', 'DNU', 'admin', '2025-03-22 16:31:06', 'admin', '2025-03-22 16:31:06', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903368390966898690', '1903363796165586946', '研发1组', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'YF1Z', 'DN1X', 'admin', '2025-03-22 16:49:22', 'admin', '2025-03-22 16:49:22', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903368508180918273', '1903363796165586946', '研发2组', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'YF2Z', 'DN2X', 'admin', '2025-03-22 16:49:50', 'admin', '2025-03-22 16:49:50', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903368576980086786', '1903363796165586946', '研发3组', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'YF3Z', 'DN3X', 'admin', '2025-03-22 16:50:06', 'admin', '2025-03-22 16:50:06', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903368660484485121', '1903363063101911041', '营销部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'YXB', 'AQU', 'admin', '2025-03-22 16:50:26', 'admin', '2025-03-22 16:50:26', '0', '0');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `dept_name`, `org_code`, `org_category`, `mobile`, `address`, `dept_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903368702242975746', '1903363063101911041', '客服部', NULL, NULL, NULL, NULL, NULL, '0', 9999, 'KFB', 'PEU', 'admin', '2025-03-22 16:50:36', 'admin', '2025-03-22 16:50:36', '0', '0');
COMMIT;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1904960886332121090', '0', '仪表板', '/analytics', 'ion:layers-outline', 'BasicLayout', 1, 1, 0, '0', '0', 1, 'YBB', 'WGS', 'admin', '2025-03-27 02:17:22', 'admin', '2025-03-27 04:01:11', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1904963087666438146', '1904960886332121090', '分析', '/dashboard/analysis', 'ant-design:account-book-outlined', '/dashboard/analytics/index', 1, 1, 0, '1', '0', 1, 'FX', 'WS', 'admin', '2025-03-27 02:26:07', 'admin', '2025-03-27 04:01:38', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1904963524960378881', '1904960886332121090', '工作台', '/dashboard/workbench', 'svg:avatar-4', '/dashboard/workspace/index', 1, 1, 0, '1', '0', 1, 'GZT', 'AWC', 'admin', '2025-03-27 02:27:52', 'admin', '2025-03-27 04:01:33', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1904964341289377794', '0', '系统管理', '/system', 'bx:bx-home', 'BasicLayout', 1, 1, 0, '0', '0', 1, 'XTGL', 'TXTG', 'admin', '2025-03-27 02:31:06', 'admin', '2025-03-27 04:01:19', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1904964771977289730', '1904964341289377794', '菜单管理', '/system/menu', 'svg:avatar-3', '/system/menu/index', 1, 1, 0, '1', '0', 1, 'CDGL', 'AUTG', 'admin', '2025-03-27 02:32:49', 'admin', '2025-03-27 04:01:19', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1905286403015036930', '1904964341289377794', '职位管理', '/system/SysPost', NULL, '/system/SysPost/index', 1, 1, 0, '1', '0', 1, 'ZWGL', 'BWTG', 'admin', '2025-03-27 23:50:52', 'admin', '2025-03-27 23:51:25', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1905286752295702530', '1904964341289377794', '角色管理', '/system/role', NULL, '/system/role/index', 1, 1, 0, '1', '0', 2, 'JSGL', 'QQTG', 'admin', '2025-03-27 23:52:15', 'admin', '2025-03-27 23:54:11', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1905286911305961473', '1904964341289377794', '部门管理', '/system/dept', NULL, '/system/dept/index', 1, 1, 0, '1', '0', 2, 'BMGL', 'UUTG', 'admin', '2025-03-27 23:52:53', 'admin', '2025-03-27 23:52:53', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1905289514605596674', '1904964341289377794', '账号管理', '/system/user', NULL, '/system/user/index', 1, 1, 0, '1', '0', 1, 'ZHGL', 'MKTG', 'admin', '2025-03-28 00:03:14', 'admin', '2025-03-28 00:03:14', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1906496908169781250', '0', '运维平台', '/devops', NULL, 'BasicLayout', 1, 1, 0, '0', '0', 1, 'YWPT', 'FXGC', 'admin', '2025-03-31 08:00:59', 'admin', '2025-03-31 08:00:59', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1906497126877569026', '1906496908169781250', '字典管理', '/cms/dict', NULL, '/devOps/dict/index', 1, 1, 0, '1', '0', 1, 'ZDGL', 'PMTG', 'admin', '2025-03-31 08:01:51', 'admin', '2025-03-31 08:01:51', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1906497949288308738', '1906496908169781250', '配置参数管理', '/devOps/config', NULL, '/devOps/config/index', 1, 1, 0, '1', '0', 1, 'PZCSGL', 'SLCOTG', 'admin', '2025-03-31 08:05:07', 'admin', '2025-03-31 08:05:07', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1915086756511322113', '0', '开发者平台', '/developer', 'ant-design:bilibili-outlined', 'BasicLayout', 1, 1, 0, '0', '0', 1, 'KFZPT', 'GNFGC', 'admin', '2025-04-24 00:53:58', 'admin', '2025-04-24 00:53:58', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1915087291272499202', '1915086756511322113', '数据源管理', '/developer/GenDatasourceConf', 'ant-design:border-bottom-outlined', '/developer/GenDatasourceConf/index', 1, 1, 0, '1', '0', 1, 'SJYGL', 'ORITG', 'admin', '2025-04-24 00:56:05', 'admin', '2025-04-24 00:59:09', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1915444331210457089', '1915086756511322113', '表管理', '/developer/table', 'ant-design:border-bottom-outlined', '/developer/table/index', 1, 1, 0, '1', '0', 1, 'BGL', 'GTG', 'admin', '2025-04-25 00:34:50', 'admin', '2025-04-25 00:34:50', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1917627602904129537', '1915086756511322113', '模板管理', '/developer/GenTemplate', 'ant-design:account-book-filled', '/developer/GenTemplate/index', 1, 1, 0, '1', '0', 1, 'MBGL', 'SSTG', 'admin', '2025-05-01 01:10:23', 'admin', '2025-05-01 01:10:23', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1917964243631968257', '1915086756511322113', '模板分组', '/developer/GenGroup', 'ant-design:copy-outlined', '/developer/GenGroup/index', 1, 1, 0, '1', '0', 1, 'MBFZ', 'SSWX', 'admin', '2025-05-01 23:28:04', 'admin', '2025-05-04 04:08:53', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1918760464650903553', '1915086756511322113', '列属性类型管理', '/developer/GenFieldType', 'ant-design:api-twotone', '/developer/GenFieldType/index', 1, 1, 0, '1', '0', 1, 'LSXLXGL', 'GNNOGTG', 'admin', '2025-05-04 04:11:58', 'admin', '2025-05-04 04:11:58', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1919364586714517505', '1915086756511322113', '代码生成', '/developer/generator', 'ant-design:chrome-filled', '/developer/generator/index', 1, 1, 0, '1', '0', 1, 'DMSC', 'WDTD', 'admin', '2025-05-05 20:12:32', 'admin', '2025-05-05 20:12:32', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1924245203837063170', '0', 'Ai管理', '/ai', 'ant-design:aliwangwang-filled', 'BasicLayout', 0, 1, 0, '0', '0', 1, 'AIGL', 'AITG', 'admin', '2025-05-19 07:26:22', 'admin', '2025-05-19 07:26:22', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1924245523698880513', '1924245203837063170', '模型配置', '/ai/aiModelConfig', 'ant-design:api-outlined', '/ai/aiModelConfig/index', 1, 1, 0, '1', '0', 1, 'MXPZ', 'SGSL', 'admin', '2025-05-19 07:27:38', 'admin', '2025-05-19 07:27:38', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1924245749365018626', '1924245203837063170', '模型平台', '/ai/aiModelPlatform', 'ant-design:apple-filled', '/ai/aiModelPlatform/index', 1, 1, 0, '1', '0', 1, 'MXPT', 'SGGC', 'admin', '2025-05-19 07:28:32', 'admin', '2025-05-19 07:28:32', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1935334108960149506', '1924245203837063170', '向量配置', '/ai/aiEmbeddingStore/index', 'ant-design:bilibili-outlined', '/ai/aiEmbeddingStore/index', 1, 1, 0, '1', '0', 1, 'XLPZ', 'TJSL', 'admin', '2025-06-18 21:49:43', 'admin', '2025-06-18 21:49:43', '0', '0');
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `menu_name`, `route_path`, `icon`, `component`, `is_show`, `keep_alive`, `is_ext`, `type`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1936087505489453057', '1924245203837063170', 'AI知识库', '/ai/aiKnowledge/index', 'ant-design:container-outlined', '/ai/aiKnowledge/index', 1, 1, 0, '1', '0', 1, 'AIZSK', 'AITYY', 'admin', '2025-06-20 23:43:27', 'admin', '2025-06-20 23:43:27', '0', '0');
COMMIT;

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_rank`, `remark`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1902741506717417474', 'DIRECTORS', '董事高管', '1', NULL, '0', 1, 'DSGG', 'AGYT', 'admin', '2025-03-20 23:18:21', 'admin', NULL, '0', '0');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_rank`, `remark`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1902741825518075906', 'HR_MANAGER', '人事经理', '2', NULL, '0', 3, 'RSJL', 'WGXG', 'admin', '2025-03-20 23:19:37', 'admin', NULL, '0', '0');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_rank`, `remark`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1902742444937084930', 'FINANCE_MANAGER', '财务经理', '2', NULL, '0', 2, 'CWJL', 'MTXG', 'admin', '2025-03-20 23:22:05', 'admin', NULL, '0', '0');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_rank`, `remark`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1902742996202848258', 'R&D_PERSONNEL', '研发人员', '3', NULL, '0', 9999, 'YFRY', 'DNWK', 'admin', '2025-03-20 23:24:16', 'admin', NULL, '0', '0');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_rank`, `remark`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1902743157553528833', 'TESTER', '测试人员', '3', NULL, '0', 9999, 'CSRY', 'IYWK', 'admin', '2025-03-20 23:24:55', 'admin', NULL, '0', '0');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_rank`, `remark`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1902743322049937409', 'DEPT_HEAD', '部门负责人', '2', NULL, '0', 4, 'BMFZR', 'UUQGW', 'admin', '2025-03-20 23:25:34', 'admin', NULL, '0', '0');
COMMIT;


-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903923413530570753', '超级管理员', 'administrator', '超级管理员', '0', 1, 'CJGLY', 'FXTGK', 'admin', '2025-03-23 08:34:50', 'admin', '2025-03-25 22:59:33', '0', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903924032509177858', '财务', 'finance', NULL, '0', 100, 'CW', 'MT', 'admin', '2025-03-23 08:34:50', 'admin', '2025-03-25 22:59:31', '0', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903924093565661186', '测试', 'test', '测试角色', '0', 9999, 'CS', 'IY', 'admin', '2025-03-23 08:34:50', 'admin', '2025-03-25 23:11:08', '0', '0');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_code`, `role_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1903924564846047233', '管理员', 'admin', NULL, '0', 2, 'GLY', 'TGK', 'admin', '2025-03-24 08:34:50', 'admin', '2025-03-24 08:34:50', '0', '0');
COMMIT;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1904960886332121090', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1904963087666438146', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1904963524960378881', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1904964341289377794', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1904964771977289730', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1905286403015036930', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1905286752295702530', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1905286911305961473', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1905289514605596674', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1906496908169781250', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1906497126877569026', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1906497949288308738', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1915086756511322113', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1915087291272499202', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1915444331210457089', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1917627602904129537', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1917964243631968257', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1918760464650903553', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1919364586714517505', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1924245203837063170', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1924245523698880513', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1924245749365018626', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1935334108960149506', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903923413530570753', '1936087505489453057', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903924032509177858', '1905289514605596674', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903924093565661186', '1905286403015036930', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903924093565661186', '1905286752295702530', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903924564846047233', '1904960886332121090', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903924564846047233', '1904963087666438146', '0');
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`, `tenant_id`) VALUES ('1903924564846047233', '1904963524960378881', '0');
COMMIT;

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` (`tenant_id`, `tenant_name`, `tenant_code`, `tenant_domain`, `tenant_contact`, `tenant_contact_phone`, `tenant_contact_email`, `tenant_contact_address`, `tenant_logo`, `tenant_type`, `tenant_desc`, `status`, `order_no`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`) VALUES ('1909266774261960705', '企安科技', 'QA', 'http://elsff.cn/', '曾先生', '109999999', 'system@elsff.cn', '北京市西城区测试街道测试小区cs单元101', 'http://elsff.cn/log.png', NULL, NULL, '0', 0, 'QAKJ', 'WPTR', 'admin', '2025-04-07 23:27:26', 'admin', '2025-04-07 23:27:26', '0');
COMMIT;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `username`, `nickname`, `sex`, `birthday`, `password`, `avatar`, `email`, `phone`, `status`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1817648592181267201', 'admin', '管理员', 1, '2025-03-29 00:00:00', '{bcrypt}$2a$10$0INtS9wxpbmvMrYSWNWqhOB90UppvT3YstBz5eZLzzFjfFlJcSEY2', NULL, '23@qq.com', '13212341234', '0', 'GLY', 'TGK', NULL, '2025-03-29 16:32:34', 'admin', '2025-03-29 21:37:08', '0', '0');
INSERT INTO `sys_user` (`user_id`, `username`, `nickname`, `sex`, `birthday`, `password`, `avatar`, `email`, `phone`, `status`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1905900734593294337', 'user1', '用户1号', 1, '2025-03-30 00:00:00', '{bcrypt}$2a$10$Xj80EX6xa00AgPGXEEOp7.8SVq7SQK9NEfXlQfFT/KHWLwhOEiTBC', NULL, 'user1@elsfs.org', '13212341235', '0', 'YH1H', 'EY1K', 'admin', '2025-03-29 16:32:00', 'admin', '2025-03-29 23:56:55', '0', '0');
INSERT INTO `sys_user` (`user_id`, `username`, `nickname`, `sex`, `birthday`, `password`, `avatar`, `email`, `phone`, `status`, `pinyin_code`, `wubi_code`, `create_by`, `create_at`, `update_by`, `update_at`, `delete_flag`, `tenant_id`) VALUES ('1905901195421474817', 'user2', '用户二号', 0, '2025-03-03 00:00:00', '{bcrypt}$2a$10$jD/7VUUdaN9h5N.RWt098uKG0waANMSGVsa3UgRsU7fyId7RUDUBy', NULL, 'user2@elsfs.org', '13212341236', '0', 'YHEH', 'EYFK', 'admin', '2025-03-29 16:33:50', 'admin', '2025-03-29 23:56:27', '0', '0');
COMMIT;

-- ----------------------------
-- Records of sys_user_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_dept` (`user_id`, `dept_id`, `tenant_id`) VALUES ('1817648592181267201', '1903363484398776322', '0');
INSERT INTO `sys_user_dept` (`user_id`, `dept_id`, `tenant_id`) VALUES ('1905900734593294337', '1903368390966898690', '0');
INSERT INTO `sys_user_dept` (`user_id`, `dept_id`, `tenant_id`) VALUES ('1905901195421474817', '1903363235735269378', '0');
COMMIT;

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` (`user_id`, `post_id`, `tenant_id`) VALUES ('1817648592181267201', '1902742444937084930', '0');
INSERT INTO `sys_user_post` (`user_id`, `post_id`, `tenant_id`) VALUES ('1905900734593294337', '1902742444937084930', '0');
INSERT INTO `sys_user_post` (`user_id`, `post_id`, `tenant_id`) VALUES ('1905901195421474817', '1902741825518075906', '0');
COMMIT;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`user_id`, `role_id`, `tenant_id`) VALUES ('1817648592181267201', '1903923413530570753', '0');
INSERT INTO `sys_user_role` (`user_id`, `role_id`, `tenant_id`) VALUES ('1817648592181267201', '1903924093565661186', '0');
INSERT INTO `sys_user_role` (`user_id`, `role_id`, `tenant_id`) VALUES ('1905900734593294337', '1903924564846047233', '0');
COMMIT;

